Avocado Prices Dashboard 19

1.Right click and add dashboard .

 Click on dashboard in the menu and select Show title and then click on Format Dashboarding Shading Green color. Under Objects Select Floating

Under dashboard select size and choose Automatic .


 Click on dashboard in the menu and select Show title .. 


Click on Format Dashboarding Shading Green color




Under Objects Select Floating



2.Drag and drop Total sales to the top left and adjust the size so that the numbers are displayed properly.


Click on Layout select Border and color as Grey



3.Drag and drop YoY Sales under total Sales adjust the size so that the numbers are displayed properly.

Click on Layout select Border and color as Grey




4.Drag and Drop Avg Price under YoY Sales and size so that the numbers are displayed properly.


 Click on Layout select Border and color as Grey.


5. Drag and drop YoY Avg Price under Avg Price and size so that the numbers are displayed properly. 


Click on Layout select Border and color as Grey.



6. Drag and drop Total Volume under YoY Avg Price and size so that the numbers are displayed properly. 


Click on Layout select Border and color as Grey.



7. Drag and drop YoY Volume  under Total Volume Price and size so that the numbers are displayed properly. 


Click on Layout select Border and color as Grey.



8. Drag and drop Sales Sheet next to the total  sales and resize  so that the numbers and text are displayed properly. Right click on legend and uncheck the Show title to remove title.



Click on Layout select Border and color as Grey.

Resize the Legend and drag and drop in the sales box .





9 . Drag and drop Avg Price Sheet next to the sales and size so that the numbers and text are displayed properly. 



Right click on legend and uncheck the Show title to remove title.


Click on Layout select Border and color as Grey.


Resize the Legend and drag and drop in the Avg Price Box.



10. Drag and drop Volume Sheet Under the sales and size so that the numbers and text are displayed properly. Right click on legend and uncheck the Show title to remove title.


Resize the Legend and drag and drop in the sales box .


Click on Layout select Border and color as Grey.



11. Drag and drop Sales by Location  Under the Avg Price and size so that the map  and text are displayed properly. Right click on legend and uncheck the Show title to remove title.


Resize the Legend and drag and drop in the sales by location box .


Click on Layout select Border and color as Grey.



12 Resize all the Boxes and try to get them to be of the same size .





13. Click on the dashboard title and enter Avocado Prices in US Select front type as Tableau Bold > Font size as 18 Bold and align to the left.




14. Inserting Colaberry Logo : Drag and drop Image from objects in the Dashboard . Pop up window appears click on choose and select Colaberry Logo from your files click OK. Logo appears on the dashboard resize it such that it fits in the title area left side to the title .





15. Inserting Avocado Picture :  Drag and drop Image from objects in the Dashboard . Pop up window appears click on choose and select Avocado picture from your files click OK. 





Avocado picture appears on the dashboard resize it such that it fits in the title area left side to the title .



Resize it by pulling the corners and drag and drop next to Colaberry Logo


 

16 . Adding the Type Filter

      Go to any sheet drag and drop Type dimension to the Filters Shelf and select Conv and Org and click OK.



16.1. Right click on the filter and select Show Filter  will be displayed on the right side of the sheet. Right Click on the filter and select Multiple Values(drop down)




16.2. Right click on the filter and select Apply to Work sheets >All using this data source



16.3. Go to dashboard select any sheet and click on analysis > Filters and select Type


16.4 . Resize the filter by pulling the pulling the corners and drag and drop in the right side of the title.


16.5. Click the right arrow and select Multiple Values (drop down list).


16.6. Click the right arrow and select Multiple Values (drop down list).

17. Click on sales sheet click on the filter sign to make it active. Like wise do it for all other sheets.












What is a Dashboard :

https://www.youtube.com/watch?v=EcZH58cFMWw&t=4s